# | NAME,C,15 | NAME_EXT,C,6 | PURPOSE,C,80 | ARGUMENTS,C,80 | CATEGORIES,C,40
|
---|
1 | ABS | | Returns absolute value of specified number | expN | Numeric data |
2 | ACCESS | | Returns the access level of the current user, as assigned with PROTECT command | | Security |
3 | ACOPY | | Copies elements from one array to another; returns number copied | source array, target array | Memory variables |
4 | ACOPY | . | ACOPY + specifies start position | source array, target array, start expN | Memory variables |
5 | ACOPY | .. | ACOPY + specifies start position and number of elements to copy | source array, target array, start expN, elements expN | Memory variables |
6 | ACOPY | ... | ACOPY + specifies start position, number of elements, and target position | source array, target array, start expN, elements expN, target expN | Memory variables |
7 | ACOS | | Returns arccosine in radians | cosine expN | Numeric data |
8 | ADEL | | Deletes array element or, if two-dimensional, elements from row or column | array name, position expN | Memory variables |
9 | ADEL | . | Deletes row or column from two-dimensional array | array name, position expN, row/column expN | Memory variables |
10 | ADIR | | Stores file characteristics (name/size/date/time/DOS attr) in array | array name | Memory variables |
11 | ADIR | . | ADIR + specifies file-name skeleton | array name, filename skeleton expC | Memory variables |
12 | ADIR | .. | ADIR + specifies file-name skeleton and DOS attributes (Dir/Hidden/Sys/Vol) | array name, filename skeleton expC, file attr expC | Memory variables |
13 | AELEMENT | | Returns number of specified element in one-dimensional array | array name, subscript1 expN | Memory variables |
14 | AELEMENT | . | Returns number of specified element in two-dimensional array | array name, subscript1 expN, subscript2 expN | Memory variables |
15 | AFIELDS | | Stores table structure in array and returns number of fields | array name | Memory variables |
16 | AFILL | | Inserts value into array; returns number of elements inserted | array name, exp | Memory variables |
17 | AFILL | . | Inserts value into array, starting at specified element | array name, exp, start expN | Memory variables |
18 | AFILL | .. | Inserts value into number of array elements starting at specified element | array name, exp, start expN, count expN | Memory variables |
19 | AGROW | | Adds element, row, or column to array; returns number of added elements | array name, expN | Memory variables |
20 | AINS | | Inserts .F. value into 1-D array or row of .F. values into 2-D array | array name, position expN | Memory variables |
21 | AINS | . | Inserts column of .F. values into 2-D array | array name, position expN, 2 | Memory variables |
22 | ALEN | | Returns number of elements in array | array name | Memory variables |
23 | ALEN | . | Returns number of elements, rows, or columns in array | array name, expN | Memory variables |
24 | ALIAS | | Returns alias name of current work area | | Table basics |
25 | ALIAS | . | Returns alias name of specified work area | alias | Table basics |
26 | ANSI | | Returns ANSI value of OEM character expression | expC | String data |
27 | ARESIZE | | Changes number of rows in array; returns number of elements in new array | array name, new rows expN | Memory variables |
28 | ARESIZE | . | ARESIZE + specifies number of columns in new array | array name, new rows expN, new cols expN | Memory variables |
29 | ARESIZE | .. | ARESIZE + specifies number of columns & whether elements retain original values | array name, new rows expN, new cols expN, retain values expN | Memory variables |
30 | ASC | | Returns ASCII value of specified character | expC | Data type conversion |
31 | ASCAN | | Searches array for expression; returns number of first matching element | array name, exp | Memory variables |
32 | ASCAN | . | ASCAN + specifies start point for search | array name, exp, start expN | Memory variables |
33 | ASCAN | .. | ASCAN + specifies start point and extent of search | array name, exp, start expN, expN | Memory variables |
34 | ASIN | | Returns arcsine of number in radians | expN | Numeric data |
35 | ASORT | | Sorts elements in 1-D array or rows in 2-D array | array name | Memory variables |
36 | ASORT | . | Sorts array from starting point | array name, start expN | Memory variables |
37 | ASORT | .. | Sorts specified number of elements/rows from start point in array | array name, start expN, expN | Memory variables |
38 | ASORT | ... | Sorts array in ascending/descending order | array name, start expN, expN, expN | Memory variables |
39 | ASUBSCRIPT | | Returns row/column number of specified element in array | array name, expN, expN | Memory variables |
40 | AT | | Returns position of first string within another string or memo field | search expC, target expC | target memo field | String data |
41 | AT | . | Returns position of nth string within another string or memo field | search expC, target expC | target memo field, occurrence expN | String data |
42 | ATAN | | Returns arctangent of number in radians | expN | Numeric data |
43 | ATN2 | | Returns arctangent of point in radians | sine expN, cosine expN | Numeric data |
44 | BAR | | Returns number of most recently selected bar in dBASE IV menu | | dBASE IV menus |
45 | BARCOUNT | | Returns number of bars in current dBASE IV menu | | dBASE IV menus |
46 | BARCOUNT | . | Returns number of bars in specified dBASE IV menu | popup name | dBASE IV menus |
47 | BARPROMPT | | Returns prompt string from active dBASE IV pop-up | bar expN | dBASE IV menus |
48 | BARPROMPT | . | Returns prompt string from specified dBASE IV pop-up | bar expN, popup name | dBASE IV menus |
49 | BEGINTRANS | | Starts a transaction; returns .T. if successful | | Shared data |
50 | BEGINTRANS | . | Starts a transaction in the specified SQL database; returns .T. if successful | database name expC | Shared data |
51 | BINTYPE | | Returns predefined type number of a specified binary field | field name | Fields/records |
52 | BITAND | | Compares bits and returns 1 if both are 1; otherwise, returns 0 | expN1, expN2 | Windows programming |
53 | BITLSHIFT | | Returns number generated by shifting bits to left | expN1, expN2 | Windows programming |
54 | BITOR | | Compares bits and returns 1 if either is 1; otherwise, returns 0 | expN1, expN2 | Windows programming |
55 | BITRSHIFT | | Returns number generated by shifting bits to right | expN1, expN2 | Windows programming |
56 | BITSET | | Tells if specified bit in binary number is ON | expN1, expN2 | Windows programming |
57 | BITXOR | | Returns 1 if one (not both) of two compared bits is 1: bitwise exclusive OR | expN1, expN2 | Windows programming |
58 | BOF | | Tests if record pointer is at beginning of file | | Fields/records |
59 | BOF | . | Tests if record pointer is at beginning of specified work area | alias | Fields/records |
60 | BOOKMARK | | Returns bookmark value for current record | | Fields/records |
61 | CATALOG | | Returns name of active catalog | | Table basics |
62 | CDOW | | Returns day of the week for given date expression | expD | Date/time data |
63 | CEILING | | Returns first integer greater than or equal to specified number | expN | Numeric data |
64 | CENTER | | Centers character string or memo field in 80-character line | expC | Memo field | String data |
65 | CENTER | . | Centers string or memo field in line of specified length | expC | Memo field, expN | String data |
66 | CENTER | .. | Pads centered string or memo field with specified character in given line length | expC | Memo field, expN, pad expC | String data |
67 | CERROR | | Returns number of last compiler error | | Error handling |
68 | CHANGE | | Tests if another user has changed record | | Shared data |
69 | CHANGE | . | Tests if another user has changed record in specified table | alias | Shared data |
70 | CHARSET | | Returns name of character set used by system or by current table | | Environment |
71 | CHARSET | . | Returns name of character set used by specified table | alias | Environment |
72 | CHOOSEPRINTER | | Opens Printer Setup dialog box, to choose printer or set print options | | Printing |
73 | CHR | | Returns character equivalent of specified ASCII value | expN | Data type conversion |
74 | CMONTH | | Returns month containing specified date | expD | Date/time data |
75 | COL | | Returns current column position in current window | | Input/output |
76 | COMMIT | | Ends a transaction initiated by BEGINTRANS; writes changes to the open files | | Shared data |
77 | COMMIT | . | Ends specified transaction initiated by BEGINTRANS; writes changes to open files | database name expC | Shared data |
78 | COS | | Returns cosine of angle | expN | Numeric data |
79 | CTOD | | Converts character expression to date expression | expC | Data type conversion |
80 | DATABASE | | Returns name of current database | | Table basics |
81 | DATE | | Returns the system date | | Date/time data |
82 | DAY | | Returns numeric value of day of month for specified date expression | expD | Date/time data |
83 | DBERROR | | Returns the number of the last IDAPI error | | Error handling |
84 | DBF | | Returns name of table open in current work area | | Table basics |
85 | DBF | . | Returns name of table open in specified work area | alias | Table basics |
86 | DBMESSAGE | | Returns error message of last IDAPI error | | Error handling |
87 | DELETED | | Indicates if current record in current table is marked for deletion | | Fields/records |
88 | DELETED | . | Indicates if record in specified work area is marked for deletion | alias | Fields/records |
89 | DESCENDING | | Tests if specified index was created with DESCENDING keyword | index expN | Table organization |
90 | DESCENDING | . | DESCENDING + specifies multiple index (.MDX) file | .MDX filename expC, index expN | Table organization |
91 | DESCENDING | .. | DESCENDING + specifies work area | index expN, alias | Table organization |
92 | DESCENDING | ... | DESCENDING + specifies multiple index (.MDX) file and work area | .MDX filename expC, index expN, alias | Table organization |
93 | DIFFERENCE | | Returns number for phonetic (SOUNDEX) difference between strings or memo fields | expC1 | memo field1, expC2 | memo field2 | String data |
94 | DISKSPACE | | Returns number of bytes available on current drive | | Disk/file utilities |
95 | DISKSPACE | . | Returns number of bytes available on specified drive | drive expN | Disk/file utilities |
96 | DMY | | Returns date in DD MONTH YY or DD MONTH YYYY format | expD | Date/time data |
97 | DOW | | Returns day of week as a number | expD | Date/time data |
98 | DTOC | | Converts date expression to character expression | expD | Data type conversion |
99 | DTOR | | Converts degrees to radians | expN | Numeric data |
100 | DTOS | | Converts date to a YYYYMMDD format character string | expD | Data type conversion |
101 | ELAPSED | | Returns the number of seconds between two specified times | time expC1, time expC2 | Date/time data |
102 | EMPTY | | Tests if specified expression or field is blank | exp | Expressions |
103 | EOF | | Tests if record pointer is at end of current file | | Fields/records |
104 | EOF | . | Tests if record pointer is at end of file in specified work area | alias | Fields/records |
105 | ERROR | | Returns the number of the most recent dBASE error | | Error handling |
106 | EXP | | Returns the base of the natural logarithm raised to specified power | expN | Numeric data |
107 | FCLOSE | | Closes file opened with FCREATE() or FOPEN(); returns .T. if successful | file handle expN | Low-level access |
108 | FCREATE | | Creates and opens file and returns file ID number | expC1 | Low-level access |
109 | FCREATE | . | Creates and opens file with specified access; returns file ID number | expC1, expC2 | Low-level access |
110 | FDATE | | Returns most recent modification date for specified file | filename | Disk/file utilities |
111 | FDECIMAL | | Returns number of decimal places in specified field | field expN | Fields/records |
112 | FDECIMAL | . | Returns number of decimal places in field in specified work area | field expN, alias | Fields/records |
113 | FEOF | | Tests if file pointer is at end of file opened with FCREATE() or FOPEN() | expN | Low-level access |
114 | FERROR | | Returns error number of most recent low-level I/O error (0 if no error) | | Low-level access |
115 | FFLUSH | | Writes specified file to disc, flushes file buffer, and leaves file open | expN | Low-level access |
116 | FGETS | | Returns character string from file pointer position to EOL character | file handle expN | Low-level access |
117 | FGETS | . | Returns specified number of characters from file pointer position | file handle expN, chars expN | Low-level access |
118 | FGETS | .. | Returns character string from file pointer to specified EOL character | file handle expN, EOL exp | Low-level access |
119 | FGETS | ... | Returns specified number of characters to specified EOL character | file handle expN, chars expN, EOL exp | Low-level access |
120 | FIELD | | Returns name of field in specified position | field expN | Fields/records |
121 | FIELD | . | Returns name of field in specified work area | field expN, alias | Fields/records |
122 | FILE | | Tests if file exists | filename | Disk/file utilities |
123 | FKLABEL | | Returns the name of a programmable function key | expN | Keyboard/mouse |
124 | FKMAX | | Returns the number of programmable function keys in the system | | Keyboard/mouse |
125 | FLDCOUNT | | Returns the number of fields in table | | Fields/records |
126 | FLDCOUNT | . | Returns the number of fields in specified work area | alias | Fields/records |
127 | FLDLIST | | Returns fields and calculated field expressions of SET FIELDS TO list | | Fields/records |
128 | FLDLIST | . | FLDLIST + specifies position of field or expression whose name to return | field expN | Fields/records |
129 | FLENGTH | | Returns length of field in current table | field expN | Fields/records |
130 | FLENGTH | . | Returns length of field in specified work area | field expN, alias | Fields/records |
131 | FLOAT | | Returns number as a float number | expN | Data type conversion |
132 | FLOCK | | Locks current table | | Shared data |
133 | FLOCK | . | Locks specified table | alias | Shared data |
134 | FLOOR | | Returns nearest integer less than or equal to specified number | expN | Numeric data |
135 | FOPEN | | Opens file and returns file handle number | filename expC | Low-level access |
136 | FOPEN | . | Opens file, returns file handle number, and sets access rights | filename expC, access expC | Low-level access |
137 | FOR | | Returns FOR clause used to create conditional index | | Table organization |
138 | FOR | . | Returns FOR clause used to create conditional index at specified position | index expN | Table organization |
139 | FOR | .. | FOR + specifies index position and .MDX file name | .MDX filename expC, index expN | Table organization |
140 | FOR | ... | FOR + specifies index position and work area | index expN, alias | Table organization |
141 | FOR | .... | FOR + specifies index position, .MDX filename, and work area | .MDX filename, index expN, alias | Table organization |
142 | FOUND | | Tests if last FIND, LOCATE, CONTINUE, SEEK, LOOKUP(), or SEEK() succeeded | | Table organization |
143 | FOUND | . | FOUND + specifies table | alias | Table organization |
144 | FPUTS | | Writes character expression and end-of-line character to specified file | file handle expN, string expC | Low-level access |
145 | FPUTS | . | FPUTS + specifies number of characters to write | file handle expN, string expC, chars expN | Low-level access |
146 | FPUTS | .. | FPUTS + specifies end-of-line character | file handle expN, string expC, EOL exp | Low-level access |
147 | FPUTS | ... | FPUTS + specifies number of characters to write and end-of-line character | file handle expN, string expC, chars expN, EOL exp | Low-level access |
148 | FREAD | | Reads specified number of characters; moves file pointer after last character | file handle expN, chars expN | Low-level access |
149 | FSEEK | | Moves file pointer specified number of bytes; returns file pointer position | file handle expN, bytes expN | Low-level access |
150 | FSEEK | . | FSEEK + specifies starting position for file pointer move | file handle expN, bytes expN, position expN | Low-level access |
151 | FSIZE | | Returns size of specified file in bytes | filename expC | Disk/file utilities |
152 | FTIME | | Returns time stamp of specified file (last time modified) | filename expC | Disk/file utilities |
153 | FUNIQUE | | Creates an 8-character file name of random numbers, with no extension | | Disk/file utilities |
154 | FUNIQUE | . | Creates a unique file name based on the skeleton of wildcards and characters | filename skeleton expC | Disk/file utilities |
155 | FV | | Returns a float that is the future value of an investment | payment expN, interest expN, term expN | Numeric data |
156 | FWRITE | | Writes characters to file, moves file pointer, returns number of bytes written | file handle expN, string expC | Low-level access |
157 | FWRITE | . | FWRITE + specifies number of characters to write | file handle expN, string expC, chars expN | Low-level access |
158 | GETCOLOR | | Displays the Choose Color dialog box | | Colors/fonts |
159 | GETCOLOR | . | Displays color dialog box with specified title | title expC | Colors/fonts |
160 | GETDIRECTORY | | Displays Choose Directory dialog box; defaults to current directory | | Disk/file utilities |
161 | GETDIRECTORY | . | Displays Choose Directory dialog box; defaults to specified directory | directory expC | Disk/file utilities |
162 | GETENV | | Returns the value of a DOS environmental variable | expC | Disk/file utilities |
163 | GETEXPR | | Displays Expression Builder (Create); returns expression | | Expressions |
164 | GETEXPR | . | Displays Expression Builder (Edit); returns expression | expression expC | Expressions |
165 | GETEXPR | .. | GETEXPR. + specifies dialog box title | expression expC, title expC | Expressions |
166 | GETEXPR | ... | GETEXPR. + specifies dialog box title and data type of resulting expression | expression expC, title expC, data type expC | Expressions |
167 | GETFILE | | Displays Open File dialog box; returns file name | | Disk/file utilities |
168 | GETFILE | . | GETFILE + file-name skeleton (accepts wildcards) | filename skeleton expC | Disk/file utilities |
169 | GETFILE | .. | GETFILE + file-name skeleton and window title | filename skeleton expC, title expC | Disk/file utilities |
170 | GETFILE | ... | GETFILE.. + determines whether dialog box opens files or tables | filename skeleton expC, title expC, filetype expL | Disk/file utilities |
171 | GETFILE | .... | GETFILE... + determines whether user can toggle between files and tables | filename skeleton expC, title expC, filetype expL, change filetype expL | Disk/file utilities |
172 | GETFONT | | Displays font dialog box so user can select a character font | | Colors/fonts |
173 | GETFONT | . | Displays font dialog box with specified title (78-character maximum) | title expC | Colors/fonts |
174 | HOME | | Returns path to directory containing DBASEWIN.EXE | | Disk/file utilities |
175 | HTOI | | Converts hexadecimal string to decimal number | expC | Data type conversion |
176 | ID | | Returns name of current user on LAN or other multiuser system | | Shared data |
177 | IIF | | Returns one of two expressions, depending on .T./.F. state of logical expression | expL, exp1, exp2 | Programs |
178 | INKEY | | Returns decimal value of first key in buffer; clears value from buffer | | Keyboard/mouse |
179 | INKEY | . | INKEY + specifies how long INKEY waits for a keystroke | seconds expN | Keyboard/mouse |
180 | INKEY | .. | INKEY + determines whether mouse click causes INKEY to return a value | mouse expC | Keyboard/mouse |
181 | INKEY | ... | INKEY + wait time and mouse return value options | seconds expN, mouse expC | Keyboard/mouse |
182 | INSPECT | | Displays object properties dialog box and current values | object reference | Objects |
183 | INT | | Returns integer portion of specified number | expN | Numeric data |
184 | ISALPHA | | Tests if first character in string or memo field is alphabetic | expC | memo field | String data |
185 | ISBLANK | | Tests if specified field or expression is blank | exp | Fields/records |
186 | ISCOLOR | | Tests if system monitor is color | | Colors/fonts |
187 | ISLOWER | | Tests if first character of string or memo field is alphabetic and lowercase | expC | memo field | String data |
188 | ISMOUSE | | Tests for presence of mouse driver | | Keyboard/mouse |
189 | ISTABLE | | Tests for existence of table in current database | table name | Table basics |
190 | ISUPPER | | Tests if first character of string or memo field is alphabetic and uppercase | expC | memo field | String data |
191 | ITOH | | Converts number to hexadecimal character string | expN1 | Data type conversion |
192 | ITOH | . | Converts number to hexadecimal string of specified length | expN1, expN2 | Data type conversion |
193 | KEY | | Returns key expression used to create index in current .MDX file | index expN | Table organization |
194 | KEY | . | Returns key expression used to create index in specified .MDX file | .MDX filename expC, index expN | Table organization |
195 | KEY | .. | Returns key expression used to create index in specified table | index expN, alias | Table organization |
196 | KEY | ... | Returns key expression used to create index in specified .MDX file and table | .MDX filename expC, index expN, alias | Table organization |
197 | KEYMATCH | | Tests if specified expression is found in current index tag of current table | exp | Table organization |
198 | KEYMATCH | . | Tests if specified expression is found in specified index tag of current table | exp, tag expN | Table organization |
199 | KEYMATCH | .. | Tests if specified expression is found in specified .NDX file | exp, index position expN | Table organization |
200 | KEYMATCH | ... | Tests if specified expression is found in specified index tag and .MDX file | exp, .MDX filename expC, tag expN | Table organization |
201 | KEYMATCH | .... | KEYMATCH... + specified table | exp, .MDX filename expC, tag expN, alias | Table organization |
202 | KEYMATCH | ..... | Tests if specified expression is found in specified index tag and table | exp, tag expN, alias | Table organization |
203 | KEYMATCH | ...... | Tests if specified expression is found in specified .NDX file and table | exp, index position expN, alias | Table organization |
204 | LASTKEY | | Returns value of key or key combination used to exit editing session | | Keyboard/mouse |
205 | LDRIVER | | Returns name of language driver current table is using | | Environment |
206 | LDRIVER | . | Returns name of language driver alias table is using | alias | Environment |
207 | LEFT | | Returns specified number of characters from beginning of string or memo field | expC | memo field, length expN | String data |
208 | LEN | | Returns number of characters in string or memo field | expC | memo field | String data |
209 | LENNUM | | Returns display length of number, including leading blanks | expN | Numeric data |
210 | LIKE | | Tests if string matches specified skeleton string | skeleton expC, expC | memo field | String data |
211 | LINENO | | Returns current line number in program, procedure, or user-defined function | | Error handling |
212 | LISTCOUNT | | Returns number of prompts in list box | form name, list box name | Objects |
213 | LISTSELECTED | | Returns first selected prompt string from a list box or combo box | form name, list box name | Objects |
214 | LISTSELECTED | . | Returns specified prompt string from a list box or combo box | form name, list box name, expN | Objects |
215 | LKSYS | | Returns time, date, or user name for locked record or file | expN | Shared data |
216 | LOCK | | Locks current record in current table | | Shared data |
217 | LOCK | . | Locks specified records in current dBASE table | record list expC | Shared data |
218 | LOCK | .. | Locks specified records in dBASE or non-dBASE table in specified work area | record list expC | bookmark list expC, alias | Shared data |
219 | LOCK | ... | Locks current record in table in specified work area | alias | Shared data |
220 | LOG | | Returns log to base e (natural logarithm) of specified number | expN | Numeric data |
221 | LOG10 | | Returns log to base 10 (common logarithm) of specified number | expN | Numeric data |
222 | LOOKUP | | Searches field for expression; returns value of another field in same record | return field 1, exp, lookup field 2 | Table organization |
223 | LOWER | | Converts uppercase letters in string or memo field to lowercase | expC | memo field | String data |
224 | LTRIM | | Removes leading spaces from string or memo field | expC | memo field | String data |
225 | LUPDATE | | Returns date of last change to current table | | Fields/records |
226 | LUPDATE | . | Returns date of last change to specified work area | alias | Fields/records |
227 | MAX | | Compares two expressions of same type; returns greater value | exp1, exp2 | Expressions |
228 | MCOL | | Returns current column position of mouse pointer | | Keyboard/mouse |
229 | MDOWN | | Tests if mouse button is pressed | | Keyboard/mouse |
230 | MDX | | Returns name of open .MDX (multiple index) file containing specified index tag | index tag expN | Table organization |
231 | MDX | . | Returns name of open .MDX file in specified work area | index tag expN, alias | Table organization |
232 | MDY | | Converts date expression to MONTH DD, YY character string | expD | Date/time data |
233 | MEMLINES | | Returns number of lines in memo field | memo field | Fields/records |
234 | MEMLINES | . | Returns number of lines of specified length in memo field | memo field, line length expN | Fields/records |
235 | MEMORY | | Returns available RAM in bytes | | Environment |
236 | MEMORY | . | Returns available RAM in bytes (<expN> ignored) | expN | Environment |
237 | MENU | | Returns name of current dBASE IV bar menu as uppercase character string | | dBASE IV menus |
238 | MESSAGE | | Returns message text for most recent dBASE error condition | | Error handling |
239 | MIN | | Compares two expressions of same type; returns lesser value | exp1, exp2 | Expressions |
240 | MLINE | | Returns first line of text from memo field | memo field | Fields/records |
241 | MLINE | . | Returns specified line of text from memo field | memo field, line number expN | Fields/records |
242 | MLINE | .. | Returns specified line of text from memo field; specifies line length | memo field, line number expN, line length expN | Fields/records |
243 | MOD | | Returns the modulus (remainder) of first number divided by second | dividend expN, divisor expN | Numeric data |
244 | MONTH | | Returns number of the month for specified date expression | expD | Date/time data |
245 | MROW | | Returns current row position of mouse pointer | | Keyboard/mouse |
246 | MSGBOX | | Opens dialog box that displays message and default pushbuttons | message expC | Forms |
247 | MSGBOX | . | Opens dialog box that displays message, default pushbuttons, and title | message expC, title expC | Forms |
248 | MSGBOX | .. | Opens dialog box that displays message, title, and specified set of pushbuttons | message expC, title expC, box type expN | Forms |
249 | NDX | | Returns name of current master .NDX file | | Table organization |
250 | NDX | . | Returns name of specified .NDX file in current table | index position expN | Table organization |
251 | NDX | .. | Returns name of specified .NDX file in specified work area | index expN, alias | Table organization |
252 | NETWORK | | Tests if dBASE is running on a network | | Shared data |
253 | NEXTKEY | | Returns decimal value of key/key combo in typeahead buffer; doesn't empty buffer | expN | Keyboard/mouse |
254 | OEM | | Returns OEM character string value of ANSI character expression | expC | String data |
255 | ORDER | | Returns name of master .NDX index file/.MDX index tag in current work area | | Table organization |
256 | ORDER | . | Returns name of master .NDX index file/.MDX index tag in specified work area | alias | Table organization |
257 | OS | | Returns operating system name and version | | Disk/file utilities |
258 | PAD | | Returns name of current or most recently chosen pad in a dBASE IV menu | | dBASE IV menus |
259 | PADPROMPT | | Returns prompt of current or most recently chosen pad in a dBASE IV menu | pad name | dBASE IV menus |
260 | PADPROMPT | . | Returns prompt of current or most recently chosen pad in specified menu bar | pad name, menu name | dBASE IV menus |
261 | PAYMENT | | Returns periodic amount needed to repay a debt | principal expN, interest expN, term expN | Numeric data |
262 | PCOL | | Returns current column position of printer head; column numbers start at 0 | | Printing |
263 | PCOUNT | | Returns number of parameters passed to program, procedure, or UDF | | Programs |
264 | PI | | Returns approximate value of pi (circle's circumference/diameter) | | Numeric data |
265 | POPUP | | Returns name of current dBASE IV pop-up menu | | dBASE IV menus |
266 | PRINTSTATUS | | Tests if default printer port has been set with SET PRINTER TO | | Printing |
267 | PRINTSTATUS | . | Tests if specified printer port has been set with SET PRINTER TO | printer port expC | Printing |
268 | PROGRAM | | Returns name of current program, procedure, or UDF | | Error handling |
269 | PROMPT | | Returns prompt of current or most recently chosen menu item | | dBASE IV menus |
270 | PROPER | | Capitalizes first letter of each word of character expression or memo field | expC | memo field | String data |
271 | PROW | | Returns current row position of printer head; row numbers start at 0 | | Printing |
272 | PUTFILE | | Displays dialog box in which user can create file name | | Disk/file utilities |
273 | PUTFILE | . | PUTFILE + specifies dialog box title | title expC | Disk/file utilities |
274 | PUTFILE | .. | PUTFILE + specifies dialog box title and default file name | title expC, filename expC | Disk/file utilities |
275 | PUTFILE | ... | PUTFILE + specifies dialog box title, default file name and extension | title expC, filename expC, extension expC | Disk/file utilities |
276 | PUTFILE | .... | PUTFILE... + specifies if dialog box displays list of all file types or tables | title expC, filename expC, extension expC, filetype expL | Disk/file utilities |
277 | PUTFILE | ..... | PUTFILE.... + specifies if user can toggle between table and non-table files | title expC, filename expC, extension expC, filetype expL, change filetype expL | Disk/file utilities |
278 | PV | | Returns a float that is the present value of an investment | payment expN, interest expN, term expN | Numeric data |
279 | RANDOM | | Returns a random decimal value between 0 and 1 | | Numeric data |
280 | RANDOM | . | Returns random decimal based on seed (positive expN) or clock (negative expN) | expN | Numeric data |
281 | RAT | | Returns position of string in another string or memo field, counted from end | search expC, target expC | target memo field | String data |
282 | RAT | . | Returns position of nth occurrence of string in another string or memo field | search expC, target expC | target memo field, nth occurrence expN | String data |
283 | READKEY | | Returns integer for key/key combo that ended full-screen editing command | | Keyboard/mouse |
284 | READMODAL | | Displays/enables form as modal window; gives focus to specified object | object reference | Forms |
285 | READMODAL | . | READMODAL + specifies if Esc key closes form | object reference, expL | Forms |
286 | READVAL | | Returns value of memory variable specified in current @...GET during a READ | | Programs |
287 | RECCOUNT | | Returns number of records in current table | | Fields/records |
288 | RECCOUNT | . | Returns number of records in specified work area | alias | Fields/records |
289 | RECNO | | Returns current record number of current table | | Fields/records |
290 | RECNO | . | Returns current record number in specified table | alias | Fields/records |
291 | RECSIZE | | Returns number of bytes in record of current table | | Fields/records |
292 | RECSIZE | . | Returns number of bytes in record of specified table | alias | Fields/records |
293 | RELATION | | Returns key expression defined with SET RELATION for current work area | expN | Table organization |
294 | RELATION | . | Returns key expression defined with SET RELATION for specified work area | expN, alias | Table organization |
295 | REPLICATE | | Returns a string or memo field repeated a specified number of times | expC | memo field, expN | String data |
296 | RESOURCE | | Returns Windows resource in specified .DLL file | resource id, DLL filename expC | Windows programming |
297 | RIGHT | | Returns specified number of characters from end of string or memo field | expC | memo field, expN | String data |
298 | RLOCK | | Locks current record in current table | | Shared data |
299 | RLOCK | . | Locks specified records in current dBASE table | record list expC | Shared data |
300 | RLOCK | .. | Locks specified records in dBASE or non-dBASE table in specified work area | record list expC | bookmark list expC, alias | Shared data |
301 | RLOCK | ... | Locks current record in table in specified work area | alias | Shared data |
302 | ROLLBACK | | Tests if last ROLLBACK command to undo an SQL transaction was successful | | Shared data |
303 | ROUND | | Returns specified number rounded to specified decimal place | expN1, expN2 | Numeric data |
304 | ROW | | Returns number of current row position in current window | | Input/output |
305 | RTOD | | Converts radians to degrees | expN | Numeric data |
306 | RTRIM | | Removes trailing spaces from string or memo field | expC | memo field | String data |
307 | RUN | | Executes a single DOS command | DOS command expC | Disk/file utilities |
308 | RUN | . | Runs a Windows application (.T.) or DOS application (.F.) | expL1, DOS command expC | Disk/file utilities |
309 | RUN | .. | Executes a single DOS command (expL2 is ignored) | DOS command expC, expL2 | Disk/file utilities |
310 | RUN | ... | Runs a Windows application (.T.) or DOS application (.F.) (expL2 is ignored) | expL1, DOS command expC, expL2 | Disk/file utilities |
311 | SECONDS | | Returns number of seconds elapsed on system clock since midnight | | Date/time data |
312 | SEEK | | Searches for first record in current indexed table with matching key field | expC | expN | Table organization |
313 | SEEK | . | Searches for first record with matching key field in indexed table in work area | expC | expN, alias | Table organization |
314 | SELECT | | Returns number of next available work area | | Table basics |
315 | SELECT | . | Tests whether specified table is in use | alias | Table basics |
316 | SET | | Returns the current value of a SET command or function key | expC | Environment |
317 | SETTO | | Returns the current value of a SET...TO command or function key | expC | Environment |
318 | SHELL | | Returns the current state of the dBASE interactive environment | | Environment |
319 | SHELL | . | Hides (.F.) or restores (.T.) the dBASE interactive environment | expL | Environment |
320 | SIGN | | Indicates sign (positive, 0, or negative) of number or float | expN | Numeric data |
321 | SIN | | Returns sine of angle of specified size in radians | expN | Numeric data |
322 | SOUNDEX | | Returns 4-character string representing sound-alike code of string or memo field | expC | memo field | String data |
323 | SPACE | | Returns specified number of space characters | expN | String data |
324 | SQLERROR | | Returns the number of the last server error | | Error handling |
325 | SQLEXEC | | Executes an SQL statement in the current database | SQL statement expC | Table basics |
326 | SQLEXEC | . | Executes an SQL statement in the specified dBASE or Paradox tables | SQL statement expC, answer table expC | Table basics |
327 | SQLMESSAGE | | Returns the most recent server error message | | Error handling |
328 | SQRT | | Returns the square root of a specified number | expN | Numeric data |
329 | STR | | Converts number to string | expN1 | Data type conversion |
330 | STR | . | Converts number to string; sets length of character string | expN1, expN2 | Data type conversion |
331 | STR | .. | Converts number to string; sets length of string and number of decimal places | expN1, expN2, expN3 | Data type conversion |
332 | STR | ... | Converts number to string; sets length of string, decimal places, pad character | expN1, expN2, expN3, expC | Data type conversion |
333 | STUFF | | Removes and replaces characters in a string | target expC | target memo field, start expN, quantity expN, replacement expC | String data |
334 | SUBSTR | | Extracts characters from string or memo field; specifies starting point | expC | memo field, start expN | String data |
335 | SUBSTR | . | Extracts characters from string/memo field; specifies start point and length | expC | memo field, start expN, length expN | String data |
336 | TAG | | Returns name of .NDX index file or .MDX tag in current master index | index number expN | Table organization |
337 | TAG | . | Returns name of tag in specified .MDX file | .MDX filename expC, index number expN | Table organization |
338 | TAG | .. | Returns name of .NDX index file or .MDX tag in specified work area | index number expN, alias | Table organization |
339 | TAG | ... | Returns name of tag in specified .MDX file in specified work area | .MDX filename expC, index number expN, alias | Table organization |
340 | TAGCOUNT | | Returns total number of open indexes and index tags (includes .NDX files) | | Table organization |
341 | TAGCOUNT | . | Returns number of active indexes in specified .MDX file | .MDX filename expC | Table organization |
342 | TAGCOUNT | .. | Returns number of active indexes in specified .MDX file and work area | .MDX filename expC, alias | Table organization |
343 | TAGNO | | Returns number of master index | | Table organization |
344 | TAGNO | . | Returns position of specified index tag | tag name expC | Table organization |
345 | TAGNO | .. | Returns position of specified tag in specified .MDX file | tag name expC, .MDX filename expC | Table organization |
346 | TAGNO | ... | Returns position of specified tag in specified .MDX file in specified work area | tag name expC, .MDX filename expC, alias | Table organization |
347 | TAN | | Returns tangent of angle of specified size in radians | expN | Numeric data |
348 | TARGET | | Returns name of table linked to current work area | expN | Table organization |
349 | TARGET | . | Returns name of table linked to specified work area | expN, alias | Table organization |
350 | TIME | | Returns system time as HH:MM:SS character string | | Date/time data |
351 | TIME | . | Returns system time as HH:MM:SS:hh character string (to hundredths of second) | exp | Date/time data |
352 | TRANSFORM | | Returns string in specified PICTURE or FUNCTION format | exp, picture expC | String data |
353 | TRIM | | Removes trailing spaces from string or memo field | expC | memo field | String data |
354 | TYPE | | Identifies data type of specified expression | exp | Expressions |
355 | UNIQUE | | Tests if current master index was created with UNIQUE keyword | | Table organization |
356 | UNIQUE | . | Tests if specified index was created with UNIQUE keyword | index position expN | Table organization |
357 | UNIQUE | .. | Tests if specified index in specified .MDX file was created with UNIQUE keyword | .MDX filename expC, index position expN | Table organization |
358 | UNIQUE | ... | Tests if specified index in specified work area was created with UNIQUE keyword | index position expN, alias | Table organization |
359 | UNIQUE | .... | Tests if index in .MDX file in work area was created with UNIQUE keyword | .MDX filename expC, index position expN, alias | Table organization |
360 | UPDATED | | Tests for changes to @...GET fields or memory variables in current window | | Input/output |
361 | UPPER | | Converts lowercase characters in string or memo field to uppercase | expC | memo field | String data |
362 | USER | | Returns the login name of the user currently logged in to a protected system | | Security |
363 | VAL | | Converts character string to numeric or float value | expC | Data type conversion |
364 | VALIDDRIVE | | Tests if specified drive exists and can be read (colon [:] is optional) | drive expC | Disk/file utilities |
365 | VARREAD | | Returns name of current memory variable or field in @...GET or current window | | Input/output |
366 | VERSION | | Returns dBASE name and version as character string | | Environment |
367 | WINDOW | | Returns name of active window | | dBASE IV windows |
368 | WORKAREA | | Returns number of currently selected work area | | Table basics |
369 | YEAR | | Returns the year of a specified date expression as a 4-digit number | expD | Date/time data |
370 | FACCESSDATE | | Returns the last date a file was opened under Windows 95 | filename expC | Windows 95 |
371 | FCREATETIME | | Returns the time a file was created under Windows 95 | filename expC | Windows 95 |
372 | FCREATEDATE | | Returns the date a file was created under Windows 95 | filename expC | Windows 95 |
373 | FNAMEMAX | | Returns the maximum allowable file-name length on the current drive or volume | | Windows 95 |
374 | FNAMEMAX | . | Returns the maximum allowable file-name length on a specified drive or volume | expC | Windows 95 |
375 | FSHORTNAME | | Returns the short name (DOS compatible) of a file created under Windows 95 | filename expC | Windows 95
|